package com.yonyou.pmclouds.experuser.mapper;

import java.util.List;

import org.apache.ibatis.annotations.CacheNamespace;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;

import com.yonyou.pmclouds.basecom.cache.RedisCache;
import com.yonyou.pmclouds.basecom.dao.BaseMapper;
import com.yonyou.pmclouds.experuser.entity.ExperUserVO;

@CacheNamespace(implementation = RedisCache.class)
public interface ExperUserMapper extends BaseMapper<ExperUserVO> {
	

	 @Select("select * from pmbd_experuser where dr = 0 and userId = #{userId} ")
	 @ResultMap("getMap")
	 List<ExperUserVO> queryExperUserByUserId(String userId);

	 @Select("select * from pmbd_experuser where dr = 0 and creationtime < #{startDate} ")
	 @ResultMap("getMap")
	 List<ExperUserVO> queryOvertimeUser(String startDate) ;
}
